﻿CREATE TABLE [flcr].[SERVICE_CONFIG_PROPERTY] (
    [SERVICE_CONFIG_PROP_ID]   INT          IDENTITY (1, 1) NOT NULL,
    [AUDIT_USER]               VARCHAR (50) NOT NULL,
    [AUDIT_DTTM]               DATETIME     NOT NULL,
    [AUDIT_DTTM_TZ]            INT          NOT NULL,
    [AUDIT_MOD_USER]           VARCHAR (50) NOT NULL,
    [AUDIT_MOD_DTTM]           DATETIME     NOT NULL,
    [AUDIT_MOD_DTTM_TZ]        INT          NOT NULL,
    [BUILTIN]                  BIT          NOT NULL,
    [ACTIVE_FLG]               BIT          NOT NULL,
    [SORT_ORDER]               INT          NOT NULL,
    [SERVICE_ID]               INT          NOT NULL,
    [PNAME_SERVICE_PROP_TYPE]  INT          NOT NULL,
    [PVALUE_SERVICE_PROP_TYPE] INT          NOT NULL,
    [PARENT_ID]                INT          NULL,
    [AUTOCOLLECT_DEFAULT_FLG]  BIT          NOT NULL
);

